/*
 Navicat Premium Data Transfer

 Source Server         : mysql
 Source Server Type    : MySQL
 Source Server Version : 50732
 Source Host           : localhost:3399
 Source Schema         : exam_system

 Target Server Type    : MySQL
 Target Server Version : 50732
 File Encoding         : 65001

 Date: 27/11/2020 12:59:01
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for exam
-- ----------------------------
DROP TABLE IF EXISTS `exam`;
CREATE TABLE `exam` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `exam_id` varchar(255) DEFAULT NULL,
  `exam_name` varchar(255) DEFAULT NULL,
  `question_id` varchar(255) DEFAULT NULL,
  `question_score` int(1) unsigned zerofill NOT NULL DEFAULT '0',
  `answer` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `subject_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `exam_qid` (`question_id`) USING BTREE,
  KEY `exam_sid` (`subject_id`) USING BTREE,
  KEY `exam_type` (`type`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=146 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of exam
-- ----------------------------
BEGIN;
INSERT INTO `exam` VALUES (133, 'bfe31ca9b813c3e41f5a13ef30ab817d', NULL, '0c63045b199afb8cb8840b9e3d457f81', 6, NULL, '单选题', 'bb1aac7bd9c85fa9ac27f1a472e86251');
INSERT INTO `exam` VALUES (134, 'bfe31ca9b813c3e41f5a13ef30ab817d', NULL, '42288081dcaf66ccee5ac9d120ae4c05', 6, NULL, '单选题', 'bb1aac7bd9c85fa9ac27f1a472e86251');
INSERT INTO `exam` VALUES (135, '12cbdb267e4619f9848d2d5393311527', NULL, 'c30f05dddc78a7a99ae6b75e5413657a', 6, NULL, '多选题', 'bb1aac7bd9c85fa9ac27f1a472e86251');
INSERT INTO `exam` VALUES (136, '2fc3eaddfd2b1c0b76b8e1427fdd91c7', NULL, 'e0633bdaf42959abb71605f61161ec37', 6, NULL, '判断题', 'bb1aac7bd9c85fa9ac27f1a472e86251');
INSERT INTO `exam` VALUES (137, '2fc3eaddfd2b1c0b76b8e1427fdd91c7', NULL, '0dfb3fc3c7c9bcd171a7fb488c5f1931', 6, NULL, '判断题', 'bb1aac7bd9c85fa9ac27f1a472e86251');
INSERT INTO `exam` VALUES (139, 'efe2f090a03d2d69c799765af9ad0797', NULL, '5a6e0230ddd7e62facde55d9bccceafa', 7, NULL, '简答题', 'bb1aac7bd9c85fa9ac27f1a472e86251');
INSERT INTO `exam` VALUES (140, 'efe2f090a03d2d69c799765af9ad0797', NULL, 'e9d621021773c52b537b355940dcdaa1', 7, NULL, '简答题', 'bb1aac7bd9c85fa9ac27f1a472e86251');
INSERT INTO `exam` VALUES (141, '839611def6dff93fbfb4da2ee75c68bf', NULL, '64c9dbb481ca1f197d9e3d3cb6e3eeca', 4, NULL, '单选题', '184041e0b11c0d335f01f8ae9b30057f');
INSERT INTO `exam` VALUES (142, '4fca3535da6f54c9835a0b14bae563d5', NULL, '4ede9025a88fc9ca34462fc1233acea8', 6, NULL, '多选题', '184041e0b11c0d335f01f8ae9b30057f');
INSERT INTO `exam` VALUES (143, '2c6bf6a61b99a20f8ce90e6793781f07', NULL, '13916b802ce0beb1332b0e1593d7ef10', 7, NULL, '判断题', '184041e0b11c0d335f01f8ae9b30057f');
INSERT INTO `exam` VALUES (144, '349438b26c0e9f3cec408c51af438a19', NULL, '4b8714a52ca4dea34c33d93880be9469', 7, NULL, '简答题', '184041e0b11c0d335f01f8ae9b30057f');
INSERT INTO `exam` VALUES (145, '66c83c303354b2167dc91af594b95253', NULL, 'b790d31e560254fbd9925386305bb40d', 2, NULL, '单选题', '709b59d854e20a729c3d1a1234cfeb6e');
COMMIT;

-- ----------------------------
-- Table structure for examInfo
-- ----------------------------
DROP TABLE IF EXISTS `examInfo`;
CREATE TABLE `examInfo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `examInfo_id` varchar(255) DEFAULT NULL,
  `subject_id` varchar(255) DEFAULT NULL,
  `long_time` varchar(11) DEFAULT NULL,
  `start` datetime DEFAULT NULL,
  `end` datetime DEFAULT NULL,
  `subject_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `examinfo_sid` (`subject_id`)
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of examInfo
-- ----------------------------
BEGIN;
INSERT INTO `examInfo` VALUES (51, '93ac5112d8d5d3f03b460cf7f886f707', '184041e0b11c0d335f01f8ae9b30057f', '120', '2020-11-26 11:11:00', '2020-11-27 11:11:00', '后端开发工程师');
INSERT INTO `examInfo` VALUES (54, '942c8237e39d063a881e48b63a6a924f', 'bb1aac7bd9c85fa9ac27f1a472e86251', '120', '2020-11-26 11:13:00', '2020-11-28 11:13:00', '前端工程师');
INSERT INTO `examInfo` VALUES (55, '053115339e92734005d33b29c4020f60', '709b59d854e20a729c3d1a1234cfeb6e', '120', '2020-11-11 13:21:00', '2020-11-14 13:21:00', 'PHP');
COMMIT;

-- ----------------------------
-- Table structure for objective_q
-- ----------------------------
DROP TABLE IF EXISTS `objective_q`;
CREATE TABLE `objective_q` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `stu_id` int(11) DEFAULT NULL,
  `single_score` int(11) DEFAULT NULL,
  `single_num` int(11) DEFAULT NULL,
  `judge_score` int(11) DEFAULT NULL,
  `judge_num` int(11) DEFAULT NULL,
  `more_score` int(11) DEFAULT NULL,
  `more_num` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `object_stuid` (`stu_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of objective_q
-- ----------------------------
BEGIN;
INSERT INTO `objective_q` VALUES (1, 1, 10, 10, 20, 10, 30, 15);
INSERT INTO `objective_q` VALUES (3, 46, 0, 2, 0, 2, 0, 1);
INSERT INTO `objective_q` VALUES (4, 48, 0, 2, 0, 2, 0, 1);
COMMIT;

-- ----------------------------
-- Table structure for option
-- ----------------------------
DROP TABLE IF EXISTS `option`;
CREATE TABLE `option` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `question_id` varchar(255) DEFAULT NULL,
  `option_id` varchar(11) DEFAULT NULL,
  `option_content` text,
  `is_Deleted` int(1) unsigned zerofill NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `option_id` (`option_id`),
  KEY `option_qid` (`question_id`)
) ENGINE=InnoDB AUTO_INCREMENT=500 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of option
-- ----------------------------
BEGIN;
INSERT INTO `option` VALUES (376, 'd9cda16e6eeeddb9d3b2935efbce5857', 'A', 'php', 0);
INSERT INTO `option` VALUES (377, 'd9cda16e6eeeddb9d3b2935efbce5857', 'B', '111', 0);
INSERT INTO `option` VALUES (378, 'd9cda16e6eeeddb9d3b2935efbce5857', 'C', '222', 0);
INSERT INTO `option` VALUES (379, 'd9cda16e6eeeddb9d3b2935efbce5857', 'D', '333', 0);
INSERT INTO `option` VALUES (380, 'e051e02d1d3904e6f29b5e6ef005bdfe', 'A', 'php', 0);
INSERT INTO `option` VALUES (381, 'e051e02d1d3904e6f29b5e6ef005bdfe', 'B', '111', 0);
INSERT INTO `option` VALUES (382, 'e051e02d1d3904e6f29b5e6ef005bdfe', 'null', 'null', 0);
INSERT INTO `option` VALUES (383, 'e051e02d1d3904e6f29b5e6ef005bdfe', 'null', 'null', 0);
INSERT INTO `option` VALUES (384, 'b38ab8c49ff3dd81382d7397acc48b52', 'A', '12', 0);
INSERT INTO `option` VALUES (385, 'b38ab8c49ff3dd81382d7397acc48b52', 'B', '123', 0);
INSERT INTO `option` VALUES (386, 'b38ab8c49ff3dd81382d7397acc48b52', 'C', '13', 0);
INSERT INTO `option` VALUES (387, 'b38ab8c49ff3dd81382d7397acc48b52', 'D', '132', 0);
INSERT INTO `option` VALUES (388, '6a050dda78cde406c0076275dd27e13b', 'A', '但是', 0);
INSERT INTO `option` VALUES (389, '6a050dda78cde406c0076275dd27e13b', 'B', '123', 0);
INSERT INTO `option` VALUES (390, '6a050dda78cde406c0076275dd27e13b', 'C', '1333333', 0);
INSERT INTO `option` VALUES (391, '6a050dda78cde406c0076275dd27e13b', 'D', '132', 0);
INSERT INTO `option` VALUES (392, '418355707ccdad558af69410a41f8436', 'A', '对', 0);
INSERT INTO `option` VALUES (393, '418355707ccdad558af69410a41f8436', 'B', '错', 0);
INSERT INTO `option` VALUES (394, 'a8612f93da8ec758b6bc8718e46f2049', 'A', '对', 1);
INSERT INTO `option` VALUES (395, 'a8612f93da8ec758b6bc8718e46f2049', 'B', '错', 1);
INSERT INTO `option` VALUES (396, 'ff7536a8e54f8824b10e1c944e00b74d', 'A', '12', 0);
INSERT INTO `option` VALUES (397, 'ff7536a8e54f8824b10e1c944e00b74d', 'B', '123', 0);
INSERT INTO `option` VALUES (398, 'ff7536a8e54f8824b10e1c944e00b74d', 'C', '13', 0);
INSERT INTO `option` VALUES (399, 'ff7536a8e54f8824b10e1c944e00b74d', 'D', '132', 0);
INSERT INTO `option` VALUES (400, '1afcc303019f2b85efd0462de30afa84', 'A', '12打都撒出撒', 0);
INSERT INTO `option` VALUES (401, '1afcc303019f2b85efd0462de30afa84', 'B', '123', 0);
INSERT INTO `option` VALUES (402, '1afcc303019f2b85efd0462de30afa84', 'C', '13', 0);
INSERT INTO `option` VALUES (403, '1afcc303019f2b85efd0462de30afa84', 'D', '132', 0);
INSERT INTO `option` VALUES (404, '7ef2a29515deb8093062acd53d43d852', 'A', '对', 0);
INSERT INTO `option` VALUES (405, '7ef2a29515deb8093062acd53d43d852', 'B', '错', 0);
INSERT INTO `option` VALUES (406, '32919e11866c5f0efe1c9d8b3b024b83', 'A', '12', 0);
INSERT INTO `option` VALUES (407, '32919e11866c5f0efe1c9d8b3b024b83', 'B', '123', 0);
INSERT INTO `option` VALUES (408, '32919e11866c5f0efe1c9d8b3b024b83', 'C', '13', 0);
INSERT INTO `option` VALUES (409, '32919e11866c5f0efe1c9d8b3b024b83', 'D', '132', 0);
INSERT INTO `option` VALUES (410, '7d22ee81e36ebf786c8240554354ef93', 'A', 's', 0);
INSERT INTO `option` VALUES (411, '7d22ee81e36ebf786c8240554354ef93', 'B', 's', 0);
INSERT INTO `option` VALUES (412, '7d22ee81e36ebf786c8240554354ef93', 'C', 's', 0);
INSERT INTO `option` VALUES (413, '7d22ee81e36ebf786c8240554354ef93', 'D', 's', 0);
INSERT INTO `option` VALUES (414, 'c811b11cd1754bc8190f5f07e8b8a113', 'A', '对', 0);
INSERT INTO `option` VALUES (415, 'c811b11cd1754bc8190f5f07e8b8a113', 'B', '错', 0);
INSERT INTO `option` VALUES (416, 'f9a98ba04e94c1f999c989d930cf2e5f', 'A', '对', 0);
INSERT INTO `option` VALUES (417, 'f9a98ba04e94c1f999c989d930cf2e5f', 'B', '错', 0);
INSERT INTO `option` VALUES (418, 'f53361628a8e1599df4cc99ea7957863', 'A', 'a', 0);
INSERT INTO `option` VALUES (419, 'f53361628a8e1599df4cc99ea7957863', 'B', 'a', 0);
INSERT INTO `option` VALUES (420, 'f53361628a8e1599df4cc99ea7957863', 'C', 'a', 0);
INSERT INTO `option` VALUES (421, 'f53361628a8e1599df4cc99ea7957863', 'D', 'a', 0);
INSERT INTO `option` VALUES (422, 'efdf31f77f7e7e4bbe4878e0a7b1f735', 'A', ' 是', 0);
INSERT INTO `option` VALUES (423, 'efdf31f77f7e7e4bbe4878e0a7b1f735', 'B', '是', 0);
INSERT INTO `option` VALUES (424, 'efdf31f77f7e7e4bbe4878e0a7b1f735', 'C', '是', 0);
INSERT INTO `option` VALUES (425, 'efdf31f77f7e7e4bbe4878e0a7b1f735', 'D', '是', 0);
INSERT INTO `option` VALUES (426, '064e48df031f6b2dd2169bf047da5d7d', 'A', '对', 0);
INSERT INTO `option` VALUES (427, '064e48df031f6b2dd2169bf047da5d7d', 'B', '错', 0);
INSERT INTO `option` VALUES (428, 'dd55b520fd244ff3977d1459412a9560', 'A', '12', 0);
INSERT INTO `option` VALUES (429, 'dd55b520fd244ff3977d1459412a9560', 'B', '123', 0);
INSERT INTO `option` VALUES (430, 'dd55b520fd244ff3977d1459412a9560', 'C', '13', 0);
INSERT INTO `option` VALUES (431, 'dd55b520fd244ff3977d1459412a9560', 'D', '132', 0);
INSERT INTO `option` VALUES (432, '08b94d2c777f2fc6dfc9ee83561d64cd', 'A', '对', 0);
INSERT INTO `option` VALUES (433, '08b94d2c777f2fc6dfc9ee83561d64cd', 'B', '错', 0);
INSERT INTO `option` VALUES (434, '1a9ee715767a5699fd3c767afcdd95d5', 'A', 'v', 0);
INSERT INTO `option` VALUES (435, '1a9ee715767a5699fd3c767afcdd95d5', 'B', 'v', 0);
INSERT INTO `option` VALUES (436, '1a9ee715767a5699fd3c767afcdd95d5', 'C', ' 测', 0);
INSERT INTO `option` VALUES (437, '1a9ee715767a5699fd3c767afcdd95d5', 'D', '测', 0);
INSERT INTO `option` VALUES (438, '118d6edfa42768915abced2a27c553d9', 'A', 's', 0);
INSERT INTO `option` VALUES (439, '118d6edfa42768915abced2a27c553d9', 'B', 's', 0);
INSERT INTO `option` VALUES (440, '118d6edfa42768915abced2a27c553d9', 'C', 's', 0);
INSERT INTO `option` VALUES (441, '118d6edfa42768915abced2a27c553d9', 'D', 's', 0);
INSERT INTO `option` VALUES (442, '9a69e55be01e8f33eae3b3400cce69ad', 'A', '的', 0);
INSERT INTO `option` VALUES (443, '9a69e55be01e8f33eae3b3400cce69ad', 'B', '的', 0);
INSERT INTO `option` VALUES (444, '9a69e55be01e8f33eae3b3400cce69ad', 'C', '的', 0);
INSERT INTO `option` VALUES (445, '9a69e55be01e8f33eae3b3400cce69ad', 'D', 'f分', 0);
INSERT INTO `option` VALUES (446, '7a5b2dda6fad77c707d379b29703d536', 'A', '对', 0);
INSERT INTO `option` VALUES (447, '7a5b2dda6fad77c707d379b29703d536', 'B', '错', 0);
INSERT INTO `option` VALUES (448, '102ff1f77abb875d0082d0b2c5711e85', 'A', '吃点撒c', 0);
INSERT INTO `option` VALUES (449, '102ff1f77abb875d0082d0b2c5711e85', 'B', '打算', 0);
INSERT INTO `option` VALUES (450, '102ff1f77abb875d0082d0b2c5711e85', 'C', '吃点撒', 0);
INSERT INTO `option` VALUES (451, '102ff1f77abb875d0082d0b2c5711e85', 'D', '吃点撒', 0);
INSERT INTO `option` VALUES (452, '05365d7d90da4ccb459d4506732a9cd5', 'A', '吃点撒', 0);
INSERT INTO `option` VALUES (453, '05365d7d90da4ccb459d4506732a9cd5', 'B', '多少啊多少啊', 0);
INSERT INTO `option` VALUES (454, '05365d7d90da4ccb459d4506732a9cd5', 'C', '都撒出大', 0);
INSERT INTO `option` VALUES (455, '05365d7d90da4ccb459d4506732a9cd5', 'D', '都擦三次', 0);
INSERT INTO `option` VALUES (456, '36e9aa94d696a303095deac2f96e1d2b', 'A', '对', 0);
INSERT INTO `option` VALUES (457, '36e9aa94d696a303095deac2f96e1d2b', 'B', '错', 0);
INSERT INTO `option` VALUES (458, '94527f3227ab0538d3d6e466b68e0a7e', 'A', '对', 0);
INSERT INTO `option` VALUES (459, '94527f3227ab0538d3d6e466b68e0a7e', 'B', '错', 0);
INSERT INTO `option` VALUES (460, '0c63045b199afb8cb8840b9e3d457f81', 'A', 'dfsa', 0);
INSERT INTO `option` VALUES (461, '0c63045b199afb8cb8840b9e3d457f81', 'B', 'fdsa', 0);
INSERT INTO `option` VALUES (462, '0c63045b199afb8cb8840b9e3d457f81', 'C', 'as', 0);
INSERT INTO `option` VALUES (463, '0c63045b199afb8cb8840b9e3d457f81', 'D', 'sa', 0);
INSERT INTO `option` VALUES (464, '42288081dcaf66ccee5ac9d120ae4c05', 'A', 'fdsa', 0);
INSERT INTO `option` VALUES (465, '42288081dcaf66ccee5ac9d120ae4c05', 'B', 'fsda', 0);
INSERT INTO `option` VALUES (466, '42288081dcaf66ccee5ac9d120ae4c05', 'C', 'f', 0);
INSERT INTO `option` VALUES (467, '42288081dcaf66ccee5ac9d120ae4c05', 'D', 'f', 0);
INSERT INTO `option` VALUES (468, 'c30f05dddc78a7a99ae6b75e5413657a', 'A', 'fds', 0);
INSERT INTO `option` VALUES (469, 'c30f05dddc78a7a99ae6b75e5413657a', 'B', 'fds', 0);
INSERT INTO `option` VALUES (470, 'c30f05dddc78a7a99ae6b75e5413657a', 'C', 'ds', 0);
INSERT INTO `option` VALUES (471, 'c30f05dddc78a7a99ae6b75e5413657a', 'D', 'sf', 0);
INSERT INTO `option` VALUES (472, 'e0633bdaf42959abb71605f61161ec37', 'A', '对', 0);
INSERT INTO `option` VALUES (473, 'e0633bdaf42959abb71605f61161ec37', 'B', '错', 0);
INSERT INTO `option` VALUES (474, '0dfb3fc3c7c9bcd171a7fb488c5f1931', 'A', '对', 0);
INSERT INTO `option` VALUES (475, '0dfb3fc3c7c9bcd171a7fb488c5f1931', 'B', '错', 0);
INSERT INTO `option` VALUES (476, '25b2eedb8db94a1ae6f7f2cdfe264000', 'A', 'fds', 0);
INSERT INTO `option` VALUES (477, '25b2eedb8db94a1ae6f7f2cdfe264000', 'B', 'fds', 0);
INSERT INTO `option` VALUES (478, '25b2eedb8db94a1ae6f7f2cdfe264000', 'C', 'fds', 0);
INSERT INTO `option` VALUES (479, '25b2eedb8db94a1ae6f7f2cdfe264000', 'D', 'fs', 0);
INSERT INTO `option` VALUES (480, 'd5f9f72672f572613ae40fcd04a4ed53', 'A', 'fds', 0);
INSERT INTO `option` VALUES (481, 'd5f9f72672f572613ae40fcd04a4ed53', 'B', 'fds', 0);
INSERT INTO `option` VALUES (482, 'd5f9f72672f572613ae40fcd04a4ed53', 'C', 'fsd', 0);
INSERT INTO `option` VALUES (483, 'd5f9f72672f572613ae40fcd04a4ed53', 'D', 'ff', 0);
INSERT INTO `option` VALUES (484, '265b31e1530e7ba592c65ab1ef978a40', 'A', '对', 0);
INSERT INTO `option` VALUES (485, '265b31e1530e7ba592c65ab1ef978a40', 'B', '错', 0);
INSERT INTO `option` VALUES (486, '64c9dbb481ca1f197d9e3d3cb6e3eeca', 'A', 'fgasg', 0);
INSERT INTO `option` VALUES (487, '64c9dbb481ca1f197d9e3d3cb6e3eeca', 'B', 'fgds', 0);
INSERT INTO `option` VALUES (488, '64c9dbb481ca1f197d9e3d3cb6e3eeca', 'C', 'gfds', 0);
INSERT INTO `option` VALUES (489, '64c9dbb481ca1f197d9e3d3cb6e3eeca', 'D', 'gfds', 0);
INSERT INTO `option` VALUES (490, '4ede9025a88fc9ca34462fc1233acea8', 'A', 'gfds', 0);
INSERT INTO `option` VALUES (491, '4ede9025a88fc9ca34462fc1233acea8', 'B', 'gdsg', 0);
INSERT INTO `option` VALUES (492, '4ede9025a88fc9ca34462fc1233acea8', 'C', 'gdfs', 0);
INSERT INTO `option` VALUES (493, '4ede9025a88fc9ca34462fc1233acea8', 'D', 'sg', 0);
INSERT INTO `option` VALUES (494, '13916b802ce0beb1332b0e1593d7ef10', 'A', '对', 0);
INSERT INTO `option` VALUES (495, '13916b802ce0beb1332b0e1593d7ef10', 'B', '错', 0);
INSERT INTO `option` VALUES (496, 'b790d31e560254fbd9925386305bb40d', 'A', 'dad', 0);
INSERT INTO `option` VALUES (497, 'b790d31e560254fbd9925386305bb40d', 'B', 'da', 0);
INSERT INTO `option` VALUES (498, 'b790d31e560254fbd9925386305bb40d', 'C', 'da', 0);
INSERT INTO `option` VALUES (499, 'b790d31e560254fbd9925386305bb40d', 'D', 'd', 0);
COMMIT;

-- ----------------------------
-- Table structure for paper
-- ----------------------------
DROP TABLE IF EXISTS `paper`;
CREATE TABLE `paper` (
  `subject_id` varchar(255) DEFAULT '0',
  `paper_start` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `is_checked` int(1) unsigned zerofill DEFAULT '0',
  `paper_score` int(11) DEFAULT '0',
  `stu_name` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `stu_id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`stu_id`),
  KEY `paper_sid` (`subject_id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of paper
-- ----------------------------
BEGIN;
INSERT INTO `paper` VALUES ('1', '2020-11-02 01:00:00', 1, 3, '嗔痴', '12345678901', 1);
INSERT INTO `paper` VALUES ('1', '2020-11-11 00:00:00', 1, 55, '李彦', '11122233345', 2);
INSERT INTO `paper` VALUES ('1', '2020-11-13 00:00:00', 0, 44, '华为', '12332112300', 3);
INSERT INTO `paper` VALUES ('1', '2020-11-12 12:01:11', 1, 88, '李华', '123123123122', 4);
INSERT INTO `paper` VALUES ('1', '2020-11-12 22:33:29', 0, 33, '李雷', '3429847238', 5);
INSERT INTO `paper` VALUES ('1', '2020-11-24 20:47:43', 0, 22, '网吧', '5456435353', 6);
INSERT INTO `paper` VALUES ('1', '2020-11-02 00:00:00', 0, 11, '嗔痴', '12345678901', 7);
INSERT INTO `paper` VALUES ('1', '2020-11-11 00:00:00', 0, 55, '李彦1', '11122233345', 8);
INSERT INTO `paper` VALUES ('1', '2020-11-13 00:00:00', 0, 22, '华为1', '12332112300', 9);
INSERT INTO `paper` VALUES ('1', '2020-11-12 12:01:11', 1, 88, '李华1', '123123123122', 10);
INSERT INTO `paper` VALUES ('1', '2020-11-12 22:33:29', 0, 77, '李雷1', '3429847238', 11);
INSERT INTO `paper` VALUES ('1', '2020-11-24 20:47:46', 0, 88, '李哥', '5435345345', 12);
INSERT INTO `paper` VALUES ('1', '2020-11-23 14:56:06', 1, 55, '李彦2', '11122233345', 13);
INSERT INTO `paper` VALUES ('1', '2020-11-23 14:56:09', 0, 44, '华为3', '12332112300', 14);
INSERT INTO `paper` VALUES ('1', '2020-11-23 14:56:11', 1, 88, '李华q', '123123123122', 15);
INSERT INTO `paper` VALUES ('1', '2020-11-23 14:56:20', 0, 33, 's李雷', '3429847238', 16);
INSERT INTO `paper` VALUES ('1', '2020-11-24 20:47:49', 0, 22, '哇嘎嘎', '54345345345', 17);
INSERT INTO `paper` VALUES ('1', '2020-11-23 02:30:26', 0, 11, '嗔痴', '12345678901', 18);
INSERT INTO `paper` VALUES ('1', '2020-11-23 14:56:23', 0, 55, '李e彦1', '11122233345', 19);
INSERT INTO `paper` VALUES ('1', '2020-11-23 14:56:26', 0, 22, '华为e1', '12332112300', 20);
INSERT INTO `paper` VALUES ('1', '2020-11-23 14:56:28', 1, 88, '李e华1', '123123123122', 21);
INSERT INTO `paper` VALUES ('1', '2020-11-23 14:56:30', 0, 77, '李fef雷1', '3429847238', 22);
INSERT INTO `paper` VALUES ('1', '2020-11-24 20:47:51', 0, 88, '李rf哥', '45345345', 23);
INSERT INTO `paper` VALUES ('1', '2020-11-23 13:52:50', 0, 0, '1', '11111122234', 24);
INSERT INTO `paper` VALUES ('1', '2020-11-23 13:52:53', 0, 0, '2', '222222', 25);
INSERT INTO `paper` VALUES ('1', '2020-11-23 13:53:03', 0, 0, '3', '333333333', 26);
INSERT INTO `paper` VALUES ('1', '2020-11-24 13:50:07', 1, 33, '刘备', '323732737276', 27);
INSERT INTO `paper` VALUES ('1', '2020-11-24 13:50:52', 1, 99, '关于', '384823782', 28);
INSERT INTO `paper` VALUES ('1', '2020-11-24 13:51:48', 1, 66, '展飞', '3727738323', 29);
INSERT INTO `paper` VALUES ('2', '2020-11-24 16:48:53', 0, 22, '陈赤', '2342342674', 30);
INSERT INTO `paper` VALUES ('2', '2020-11-24 16:48:53', 1, 55, '陈吃', '342523523', 31);
INSERT INTO `paper` VALUES ('3', '2020-11-24 16:50:21', 0, 56, '黄车', '237682', 32);
INSERT INTO `paper` VALUES ('1', '2020-11-24 20:54:10', 1, 88, '走开', '4234242', 33);
INSERT INTO `paper` VALUES ('1', '2020-11-23 14:56:36', 1, 3, 'fe嗔痴', '12345678901', 34);
INSERT INTO `paper` VALUES ('1', '2020-11-23 14:56:36', 1, 93, '晚安吧', '834782374', 35);
INSERT INTO `paper` VALUES ('1', '2020-11-23 14:56:36', 1, 55, '而非', '54546456', 36);
INSERT INTO `paper` VALUES ('1', '2020-11-23 14:56:36', 1, 40, '对方的', '342424', 37);
INSERT INTO `paper` VALUES ('1', '2020-11-25 16:41:02', 1, 34, 'df', '3242424', 38);
INSERT INTO `paper` VALUES ('1', '2020-11-25 16:41:02', 1, 30, '冻分割肉', '32424', 39);
INSERT INTO `paper` VALUES ('1', '2020-11-25 16:41:02', 1, 50, '沙发上', '21314144', 40);
INSERT INTO `paper` VALUES ('1', '2020-11-25 16:41:02', 1, 80, '当时', '423424', 41);
INSERT INTO `paper` VALUES ('1', '2020-11-25 16:41:02', 1, 80, '飞的高', '342564', 42);
INSERT INTO `paper` VALUES ('1', '2020-11-25 16:41:02', 1, 90, '奋斗', '34534', 43);
INSERT INTO `paper` VALUES ('1', '2020-11-25 16:41:02', 1, 70, '当多', '5435', 44);
INSERT INTO `paper` VALUES ('1', NULL, 0, 0, '法国v', '234235235435', 45);
INSERT INTO `paper` VALUES ('1', NULL, 0, 0, '法国v', '23424353', 46);
INSERT INTO `paper` VALUES ('c15a858ca1d20eb23011a7fa2f14db29', NULL, 0, 0, '阿道夫', 'MTg3MjM3ODIzNzg=', 47);
INSERT INTO `paper` VALUES ('bb1aac7bd9c85fa9ac27f1a472e86251', NULL, 0, 0, '黄金坑', 'MTg3MjM3ODIzNzg=', 48);
COMMIT;

-- ----------------------------
-- Table structure for question
-- ----------------------------
DROP TABLE IF EXISTS `question`;
CREATE TABLE `question` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subject_name` varchar(255) DEFAULT NULL,
  `subject_id` varchar(255) DEFAULT NULL,
  `question_id` varchar(255) DEFAULT NULL COMMENT '时间戳md5加密,32位',
  `question_type` varchar(255) DEFAULT NULL,
  `question_content` text,
  `is_selected` int(1) unsigned zerofill DEFAULT '0',
  `answer` varchar(255) DEFAULT NULL,
  `is_Deleted` int(1) unsigned zerofill NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `question_sid` (`subject_id`),
  KEY `question_qid` (`question_id`),
  KEY `question_type` (`question_type`)
) ENGINE=InnoDB AUTO_INCREMENT=199 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of question
-- ----------------------------
BEGIN;
INSERT INTO `question` VALUES (177, '前端工程师', 'bb1aac7bd9c85fa9ac27f1a472e86251', '0c63045b199afb8cb8840b9e3d457f81', '单选题', 'dcsafdsa', 1, 'D', 0);
INSERT INTO `question` VALUES (178, '前端工程师', 'bb1aac7bd9c85fa9ac27f1a472e86251', '42288081dcaf66ccee5ac9d120ae4c05', '单选题', 'dsfafsa', 1, 'D', 0);
INSERT INTO `question` VALUES (179, '前端工程师', 'bb1aac7bd9c85fa9ac27f1a472e86251', 'c30f05dddc78a7a99ae6b75e5413657a', '多选题', 'fdsafdsa', 1, 'AB', 0);
INSERT INTO `question` VALUES (180, '前端工程师', 'bb1aac7bd9c85fa9ac27f1a472e86251', 'e0633bdaf42959abb71605f61161ec37', '判断题', 'fsdfdsf', 1, 'A', 0);
INSERT INTO `question` VALUES (181, '前端工程师', 'bb1aac7bd9c85fa9ac27f1a472e86251', '1fd43712d88dd6ad646165af15371e99', '简答题', 'fdsdaf', 0, NULL, 0);
INSERT INTO `question` VALUES (182, '前端工程师', 'bb1aac7bd9c85fa9ac27f1a472e86251', '5a6e0230ddd7e62facde55d9bccceafa', '简答题', 'gterhgtd', 1, NULL, 0);
INSERT INTO `question` VALUES (183, '前端工程师', 'bb1aac7bd9c85fa9ac27f1a472e86251', 'e9d621021773c52b537b355940dcdaa1', '简答题', 'hgfdghdfhg', 1, NULL, 0);
INSERT INTO `question` VALUES (184, '前端工程师', 'bb1aac7bd9c85fa9ac27f1a472e86251', '0dfb3fc3c7c9bcd171a7fb488c5f1931', '判断题', 'hgfdfddg', 1, 'A', 0);
INSERT INTO `question` VALUES (185, '1', '1', '25b2eedb8db94a1ae6f7f2cdfe264000', '单选题', 'frewfes', 0, 'D', 0);
INSERT INTO `question` VALUES (186, '1', '1', 'd5f9f72672f572613ae40fcd04a4ed53', '多选题', 'dsfsfds', 0, 'BC', 0);
INSERT INTO `question` VALUES (187, '1', '1', '265b31e1530e7ba592c65ab1ef978a40', '判断题', 'gdfsgsdg', 0, 'A', 0);
INSERT INTO `question` VALUES (188, '1', '1', '8561200598f601b1dfb0e3d572ddca95', '简答题', 'gdfsfds', 0, NULL, 0);
INSERT INTO `question` VALUES (189, '1', '1', 'c3f53d1dd47fae5392638cff65e6373a', '简答题', 'gfdsgsg', 0, NULL, 0);
INSERT INTO `question` VALUES (190, '1', '1', '251e0573659a851c0ce9646e77cd673c', '简答题', 'hgrddf', 0, NULL, 0);
INSERT INTO `question` VALUES (191, '后端开发工程师', '184041e0b11c0d335f01f8ae9b30057f', '64c9dbb481ca1f197d9e3d3cb6e3eeca', '单选题', 'fvadvfda', 1, 'D', 0);
INSERT INTO `question` VALUES (192, '后端开发工程师', '184041e0b11c0d335f01f8ae9b30057f', '4ede9025a88fc9ca34462fc1233acea8', '多选题', 'gfdsgdsfgd', 1, 'AB', 0);
INSERT INTO `question` VALUES (193, '后端开发工程师', '184041e0b11c0d335f01f8ae9b30057f', '13916b802ce0beb1332b0e1593d7ef10', '判断题', 'gfsdgsdg', 1, 'A', 0);
INSERT INTO `question` VALUES (194, '后端开发工程师', '184041e0b11c0d335f01f8ae9b30057f', '4b8714a52ca4dea34c33d93880be9469', '简答题', 'hbgfxbgfdb', 1, NULL, 0);
INSERT INTO `question` VALUES (195, '后端开发工程师', '184041e0b11c0d335f01f8ae9b30057f', '81bd181e3e74f39d955a63dfeac6b90c', '简答题', 'bgfdbgfdbgf', 0, NULL, 0);
INSERT INTO `question` VALUES (196, 'PHP', '709b59d854e20a729c3d1a1234cfeb6e', 'a07d9dac4de0dbcaf812f7412fd1efda', '简答题', 'fewrfew', 0, NULL, 0);
INSERT INTO `question` VALUES (197, 'PHP', '709b59d854e20a729c3d1a1234cfeb6e', '14f35cf5584d83c2f079ec9ec955f14a', '简答题', 'vfsvfrdsvf', 0, NULL, 0);
INSERT INTO `question` VALUES (198, 'PHP', '709b59d854e20a729c3d1a1234cfeb6e', 'b790d31e560254fbd9925386305bb40d', '单选题', 'nini', 1, 'C', 0);
COMMIT;

-- ----------------------------
-- Table structure for random
-- ----------------------------
DROP TABLE IF EXISTS `random`;
CREATE TABLE `random` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `exam_id` varchar(255) DEFAULT NULL,
  `subject_id` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `num` int(1) DEFAULT NULL,
  `question_score` int(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of random
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for subject
-- ----------------------------
DROP TABLE IF EXISTS `subject`;
CREATE TABLE `subject` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subject_name` varchar(255) DEFAULT NULL,
  `subject_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `subject_id` (`subject_id`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of subject
-- ----------------------------
BEGIN;
INSERT INTO `subject` VALUES (39, '前端工程师', 'bb1aac7bd9c85fa9ac27f1a472e86251');
INSERT INTO `subject` VALUES (40, 'PHP', '709b59d854e20a729c3d1a1234cfeb6e');
INSERT INTO `subject` VALUES (41, '后端开发工程师', '184041e0b11c0d335f01f8ae9b30057f');
INSERT INTO `subject` VALUES (42, '1', '1');
INSERT INTO `subject` VALUES (43, '产品经理', 'c15a858ca1d20eb23011a7fa2f14db29');
COMMIT;

-- ----------------------------
-- Table structure for subjective_q
-- ----------------------------
DROP TABLE IF EXISTS `subjective_q`;
CREATE TABLE `subjective_q` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `stu_id` int(11) DEFAULT NULL,
  `question_id` varchar(255) DEFAULT NULL,
  `question_content` text,
  `subjective_score` int(11) DEFAULT NULL,
  `subjective_answer` varchar(255) DEFAULT NULL,
  `question_score` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `subject_stuid` (`stu_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of subjective_q
-- ----------------------------
BEGIN;
INSERT INTO `subjective_q` VALUES (1, 1, '1', '1+1=?', 10, '3', 10);
INSERT INTO `subjective_q` VALUES (2, 2, '2', '嗔痴是笨蛋', 10, '本来就是', NULL);
INSERT INTO `subjective_q` VALUES (3, 3, '22', '二组牛皮', 100, '那是真的牛', NULL);
INSERT INTO `subjective_q` VALUES (4, 46, '5a6e0230ddd7e62facde55d9bccceafa', 'gterhgtd', 7, '0', NULL);
INSERT INTO `subjective_q` VALUES (5, 46, 'e9d621021773c52b537b355940dcdaa1', 'hgfdghdfhg', 7, '0', NULL);
INSERT INTO `subjective_q` VALUES (6, 48, '5a6e0230ddd7e62facde55d9bccceafa', 'gterhgtd', 7, '0', NULL);
INSERT INTO `subjective_q` VALUES (7, 48, 'e9d621021773c52b537b355940dcdaa1', 'hgfdghdfhg', 7, '0', NULL);
COMMIT;

-- ----------------------------
-- Table structure for teacher
-- ----------------------------
DROP TABLE IF EXISTS `teacher`;
CREATE TABLE `teacher` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `teacher_id` varchar(255) DEFAULT NULL,
  `teacher_name` varchar(255) DEFAULT NULL,
  `teacher_phone` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `phone` (`teacher_phone`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of teacher
-- ----------------------------
BEGIN;
INSERT INTO `teacher` VALUES (1, '18437769655', '李彦', '18437769655');
INSERT INTO `teacher` VALUES (2, '18255185821', '胡佳慧', '18255185821');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
